Profiling Report

Dataset statistics

Number of variables	17
Number of observations	8392320
Missing cells	6088797
Missing cells (%)	4.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	1.1 GiB
Average record size in memory	136.0 B

Variable types

Categorical	2
Text	1
Numeric	14

Alerts

`bx_gse` is highly overall correlated with `bx_gsm`	High correlation
`bx_gsm` is highly overall correlated with `bx_gse`	High correlation
`by_gse` is highly overall correlated with `by_gsm` and 2 other fields	High correlation
`by_gsm` is highly overall correlated with `by_gse` and 2 other fields	High correlation
`bz_gse` is highly overall correlated with `bz_gsm` and 2 other fields	High correlation
`bz_gsm` is highly overall correlated with `bz_gse` and 2 other fields	High correlation
`period` is highly overall correlated with `source`	High correlation
`phi_gse` is highly overall correlated with `by_gse` and 2 other fields	High correlation
`phi_gsm` is highly overall correlated with `by_gse` and 2 other fields	High correlation
`source` is highly overall correlated with `period`	High correlation
`speed` is highly overall correlated with `temperature`	High correlation
`temperature` is highly overall correlated with `speed`	High correlation
`theta_gse` is highly overall correlated with `bz_gse` and 2 other fields	High correlation
`theta_gsm` is highly overall correlated with `bz_gse` and 2 other fields	High correlation
`bx_gse` has 325888 (3.9%) missing values	Missing
`by_gse` has 325888 (3.9%) missing values	Missing
`bz_gse` has 325888 (3.9%) missing values	Missing
`theta_gse` has 325888 (3.9%) missing values	Missing
`phi_gse` has 326388 (3.9%) missing values	Missing
`bx_gsm` has 325888 (3.9%) missing values	Missing
`by_gsm` has 325888 (3.9%) missing values	Missing
`bz_gsm` has 325888 (3.9%) missing values	Missing
`theta_gsm` has 325888 (3.9%) missing values	Missing
`phi_gsm` has 326388 (3.9%) missing values	Missing
`bt` has 325888 (3.9%) missing values	Missing
`density` has 684890 (8.2%) missing values	Missing
`speed` has 689555 (8.2%) missing values	Missing
`temperature` has 811768 (9.7%) missing values	Missing
`source` has 316816 (3.8%) missing values	Missing

Reproduction

Analysis started	2024-01-23 07:44:15.659954
Analysis finished	2024-01-23 08:23:18.451716
Duration	39 minutes and 2.79 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

period
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	64.0 MiB

train_c	3507840
train_b	3155040
train_a	1729440

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	58746240
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	train_a
2nd row	train_a
3rd row	train_a
4th row	train_a
5th row	train_a

Common Values

Value	Count	Frequency (%)
train_c	3507840	41.8%
train_b	3155040	37.6%
train_a	1729440	20.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
train_c	3507840	41.8%
train_b	3155040	37.6%
train_a	1729440	20.6%

Most occurring characters

Value	Count	Frequency (%)
a	10121760	17.2%
t	8392320	14.3%
r	8392320	14.3%
i	8392320	14.3%
n	8392320	14.3%
_	8392320	14.3%
c	3507840	6.0%
b	3155040	5.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	50353920	85.7%
Connector Punctuation	8392320	14.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	10121760	20.1%
t	8392320	16.7%
r	8392320	16.7%
i	8392320	16.7%
n	8392320	16.7%
c	3507840	7.0%
b	3155040	6.3%

Connector Punctuation

Value	Count	Frequency (%)
_	8392320	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	50353920	85.7%
Common	8392320	14.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	10121760	20.1%
t	8392320	16.7%
r	8392320	16.7%
i	8392320	16.7%
n	8392320	16.7%
c	3507840	7.0%
b	3155040	6.3%

Common

Value	Count	Frequency (%)
_	8392320	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	58746240	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	10121760	17.2%
t	8392320	14.3%
r	8392320	14.3%
i	8392320	14.3%
n	8392320	14.3%
_	8392320	14.3%
c	3507840	6.0%
b	3155040	5.4%

timedelta
Text

Distinct	3507840
Distinct (%)	41.8%
Missing	0
Missing (%)	0.0%
Memory size	64.0 MiB

Length

Max length	18
Median length	17
Mean length	17.42862
Min length	15

Characters and Unicode

Total characters	146266560
Distinct characters	16
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	352800 ?
Unique (%)	4.2%

Sample

1st row	0 days 00:00:00
2nd row	0 days 00:01:00
3rd row	0 days 00:02:00
4th row	0 days 00:03:00
5th row	0 days 00:04:00

Value	Count	Frequency (%)
days	8392320	33.3%
04:16:00	5828	< 0.1%
04:02:00	5828	< 0.1%
03:53:00	5828	< 0.1%
03:54:00	5828	< 0.1%
03:55:00	5828	< 0.1%
03:56:00	5828	< 0.1%
03:57:00	5828	< 0.1%
03:58:00	5828	< 0.1%
03:59:00	5828	< 0.1%
Other values (3867)	16732188	66.5%

Most occurring characters

Value	Count	Frequency (%)
0	25938672	17.7%
	16784640	11.5%
:	16784640	11.5%
1	12781392	8.7%
d	8392320	5.7%
a	8392320	5.7%
y	8392320	5.7%
s	8392320	5.7%
2	8143152	5.6%
3	5834352	4.0%
Other values (6)	26430432	18.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	79128000	54.1%
Lowercase Letter	33569280	23.0%
Space Separator	16784640	11.5%
Other Punctuation	16784640	11.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	25938672	32.8%
1	12781392	16.2%
2	8143152	10.3%
3	5834352	7.4%
4	5383872	6.8%
5	5332032	6.7%
8	3931872	5.0%
6	3931872	5.0%
7	3931872	5.0%
9	3918912	5.0%

Lowercase Letter

Value	Count	Frequency (%)
d	8392320	25.0%
a	8392320	25.0%
y	8392320	25.0%
s	8392320	25.0%

Space Separator

Value	Count	Frequency (%)
	16784640	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	16784640	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	112697280	77.0%
Latin	33569280	23.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	25938672	23.0%
	16784640	14.9%
:	16784640	14.9%
1	12781392	11.3%
2	8143152	7.2%
3	5834352	5.2%
4	5383872	4.8%
5	5332032	4.7%
8	3931872	3.5%
6	3931872	3.5%
Other values (2)	7850784	7.0%

Latin

Value	Count	Frequency (%)
d	8392320	25.0%
a	8392320	25.0%
y	8392320	25.0%
s	8392320	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	146266560	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	25938672	17.7%
	16784640	11.5%
:	16784640	11.5%
1	12781392	8.7%
d	8392320	5.7%
a	8392320	5.7%
y	8392320	5.7%
s	8392320	5.7%
2	8143152	5.6%
3	5834352	4.0%
Other values (6)	26430432	18.1%

bx_gse
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	5758
Distinct (%)	0.1%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	-0.66101671

Minimum	-54.63
Maximum	55.55
Zeros	6788
Zeros (%)	0.1%
Negative	4500158
Negative (%)	53.6%
Memory size	64.0 MiB

Quantile statistics

Minimum	-54.63
5-th percentile	-6.3
Q1	-3.27
median	-0.67
Q3	2.02
95-th percentile	4.91
Maximum	55.55
Range	110.18
Interquartile range (IQR)	5.29

Descriptive statistics

Standard deviation	3.6697301
Coefficient of variation (CV)	-5.5516449
Kurtosis	1.872836
Mean	-0.66101671
Median Absolute Deviation (MAD)	2.64
Skewness	-0.12226213
Sum	-5332046.4
Variance	13.466919
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.94	8771	0.1%
-2.59	8647	0.1%
-3.09	8643	0.1%
-2.84	8606	0.1%
-2.8	8583	0.1%
-2.92	8572	0.1%
1.96	8566	0.1%
-2.83	8564	0.1%
-2.34	8564	0.1%
2.09	8558	0.1%
Other values (5748)	7980358	95.1%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-54.63	1	< 0.1%
-54.25	1	< 0.1%
-53.68	1	< 0.1%
-52.87	1	< 0.1%
-51.77	1	< 0.1%
-51.08	1	< 0.1%
-50.21	1	< 0.1%
-49.74	1	< 0.1%
-49.69	1	< 0.1%
-49.61	1	< 0.1%

Value	Count	Frequency (%)
55.55	1	< 0.1%
41.13	1	< 0.1%
32.89	1	< 0.1%
32.55	1	< 0.1%
32.51	1	< 0.1%
31.99	2	< 0.1%
31.91	2	< 0.1%
31.9	1	< 0.1%
31.72	1	< 0.1%
31.7	1	< 0.1%

by_gse
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6677
Distinct (%)	0.1%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.10978711

Minimum	-51.69
Maximum	57.6
Zeros	7480
Zeros (%)	0.1%
Negative	3947423
Negative (%)	47.0%
Memory size	64.0 MiB

Quantile statistics

Minimum	-51.69
5-th percentile	-5.94
Q1	-2.46
median	0.11
Q3	2.64
95-th percentile	6.16
Maximum	57.6
Range	109.29
Interquartile range (IQR)	5.1

Descriptive statistics

Standard deviation	3.9753398
Coefficient of variation (CV)	36.20953
Kurtosis	3.2015418
Mean	0.10978711
Median Absolute Deviation (MAD)	2.55
Skewness	0.12733726
Sum	885590.29
Variance	15.803327
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.48	8736	0.1%
1.23	8716	0.1%
1.69	8688	0.1%
1.71	8662	0.1%
1.73	8658	0.1%
1.94	8573	0.1%
1.21	8553	0.1%
1.19	8529	0.1%
1.46	8509	0.1%
1.67	8507	0.1%
Other values (6667)	7980301	95.1%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-51.69	1	< 0.1%
-48.95	1	< 0.1%
-47.63	1	< 0.1%
-47.48	1	< 0.1%
-46.52	1	< 0.1%
-46.18	1	< 0.1%
-46.14	1	< 0.1%
-46.13	1	< 0.1%
-46.1	1	< 0.1%
-46.05	1	< 0.1%

Value	Count	Frequency (%)
57.6	1	< 0.1%
57.02	1	< 0.1%
56.96	1	< 0.1%
56.86	1	< 0.1%
56.74	1	< 0.1%
56.67	1	< 0.1%
56.43	1	< 0.1%
55.99	1	< 0.1%
55.88	1	< 0.1%
55.87	1	< 0.1%

bz_gse
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6919
Distinct (%)	0.1%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	-0.022742309

Minimum	-55
Maximum	74.03
Zeros	13396
Zeros (%)	0.2%
Negative	4011589
Negative (%)	47.8%
Memory size	64.0 MiB

Quantile statistics

Minimum	-55
5-th percentile	-5.12
Q1	-1.7
median	0.01
Q3	1.69
95-th percentile	5.05
Maximum	74.03
Range	129.03
Interquartile range (IQR)	3.39

Descriptive statistics

Standard deviation	3.3519724
Coefficient of variation (CV)	-147.38927
Kurtosis	8.3485501
Mean	-0.022742309
Median Absolute Deviation (MAD)	1.7
Skewness	-0.30514539
Sum	-183449.29
Variance	11.235719
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.07	14225	0.2%
-0.1	14131	0.2%
0.02	14110	0.2%
0.08	14058	0.2%
0.14	14022	0.2%
0.16	14013	0.2%
0.2	13963	0.2%
-0.08	13944	0.2%
0.15	13924	0.2%
0.11	13924	0.2%
Other values (6909)	7926118	94.4%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-55	1	< 0.1%
-54.84	1	< 0.1%
-54.4	1	< 0.1%
-54.27	1	< 0.1%
-54.26	1	< 0.1%
-54.24	1	< 0.1%
-54.09	1	< 0.1%
-53.05	1	< 0.1%
-52.85	1	< 0.1%
-52.49	1	< 0.1%

Value	Count	Frequency (%)
74.03	1	< 0.1%
57.3	1	< 0.1%
52.42	1	< 0.1%
51.42	1	< 0.1%
50.89	1	< 0.1%
50.86	1	< 0.1%
49.62	1	< 0.1%
49.61	1	< 0.1%
49.01	1	< 0.1%
48.87	1	< 0.1%

theta_gse
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	17958
Distinct (%)	0.2%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.15456281

Minimum	-89.89
Maximum	89.94
Zeros	1977
Zeros (%)	< 0.1%
Negative	4017359
Negative (%)	47.9%
Memory size	64.0 MiB

Quantile statistics

Minimum	-89.89
5-th percentile	-54.03
Q1	-21.45
median	0.14
Q3	21.68
95-th percentile	54.54
Maximum	89.94
Range	179.83
Interquartile range (IQR)	43.13

Descriptive statistics

Standard deviation	32.129161
Coefficient of variation (CV)	207.87122
Kurtosis	-0.25788384
Mean	0.15456281
Median Absolute Deviation (MAD)	21.57
Skewness	0.0029833965
Sum	1246770.4
Variance	1032.283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1977	< 0.1%
-3.71	1140	< 0.1%
-2.52	1120	< 0.1%
1.79	1115	< 0.1%
4.83	1111	< 0.1%
-1.07	1111	< 0.1%
-2.81	1108	< 0.1%
0.07	1108	< 0.1%
-0.23	1108	< 0.1%
2.96	1100	< 0.1%
Other values (17948)	8054434	96.0%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-89.89	1	< 0.1%
-89.86	2	< 0.1%
-89.85	1	< 0.1%
-89.82	1	< 0.1%
-89.81	2	< 0.1%
-89.8	2	< 0.1%
-89.79	1	< 0.1%
-89.78	2	< 0.1%
-89.77	5	< 0.1%
-89.76	2	< 0.1%

Value	Count	Frequency (%)
89.94	1	< 0.1%
89.9	1	< 0.1%
89.87	1	< 0.1%
89.86	1	< 0.1%
89.85	2	< 0.1%
89.8	3	< 0.1%
89.79	2	< 0.1%
89.78	1	< 0.1%
89.75	1	< 0.1%
89.74	1	< 0.1%

phi_gse
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	36001
Distinct (%)	0.4%
Missing	326388
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	194.17589

Minimum	0
Maximum	360
Zeros	330
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	64.0 MiB

Quantile statistics

Minimum	0
5-th percentile	29.51
Q1	124.07
median	176.86
Q3	286.42
95-th percentile	340.28
Maximum	360
Range	360
Interquartile range (IQR)	162.35

Descriptive statistics

Standard deviation	96.628127
Coefficient of variation (CV)	0.49763196
Kurtosis	-1.0718166
Mean	194.17589
Median Absolute Deviation (MAD)	77.94
Skewness	-0.026555431
Sum	1.5662095 × 10⁹
Variance	9336.9949
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
135	733	< 0.1%
180	554	< 0.1%
153.43	540	< 0.1%
315	526	< 0.1%
134.07	491	< 0.1%
146.31	491	< 0.1%
138.12	490	< 0.1%
144.35	490	< 0.1%
138.94	485	< 0.1%
134.74	483	< 0.1%
Other values (35991)	8060649	96.0%
(Missing)	326388	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	330	< 0.1%
0.01	134	< 0.1%
0.02	133	< 0.1%
0.03	123	< 0.1%
0.04	147	< 0.1%
0.05	157	< 0.1%
0.06	194	< 0.1%
0.07	162	< 0.1%
0.08	202	< 0.1%
0.09	163	< 0.1%

Value	Count	Frequency (%)
360	74	< 0.1%
359.99	151	< 0.1%
359.98	136	< 0.1%
359.97	141	< 0.1%
359.96	134	< 0.1%
359.95	174	< 0.1%
359.94	191	< 0.1%
359.93	199	< 0.1%
359.92	176	< 0.1%
359.91	180	< 0.1%

bx_gsm
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	5740
Distinct (%)	0.1%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	-0.66086633

Minimum	-54.63
Maximum	55.54
Zeros	6809
Zeros (%)	0.1%
Negative	4500605
Negative (%)	53.6%
Memory size	64.0 MiB

Quantile statistics

Minimum	-54.63
5-th percentile	-6.3
Q1	-3.27
median	-0.67
Q3	2.02
95-th percentile	4.91
Maximum	55.54
Range	110.17
Interquartile range (IQR)	5.29

Descriptive statistics

Standard deviation	3.6676047
Coefficient of variation (CV)	-5.5496922
Kurtosis	1.875649
Mean	-0.66086633
Median Absolute Deviation (MAD)	2.64
Skewness	-0.12274573
Sum	-5330833.3
Variance	13.451324
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.94	8768	0.1%
-2.59	8760	0.1%
-3.09	8747	0.1%
-2.84	8699	0.1%
1.96	8631	0.1%
-3.05	8581	0.1%
1.69	8550	0.1%
-2.8	8549	0.1%
2.09	8542	0.1%
-3.34	8533	0.1%
Other values (5730)	7980072	95.1%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-54.63	1	< 0.1%
-54.24	1	< 0.1%
-53.68	1	< 0.1%
-52.86	1	< 0.1%
-51.77	1	< 0.1%
-51.07	1	< 0.1%
-50.2	1	< 0.1%
-49.73	1	< 0.1%
-49.68	1	< 0.1%
-49.6	1	< 0.1%

Value	Count	Frequency (%)
55.54	1	< 0.1%
41.13	1	< 0.1%
32.89	1	< 0.1%
32.55	1	< 0.1%
32.52	1	< 0.1%
31.99	2	< 0.1%
31.91	2	< 0.1%
31.9	1	< 0.1%
31.72	1	< 0.1%
31.7	1	< 0.1%

by_gsm
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	6636
Distinct (%)	0.1%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.088421101

Minimum	-52.68
Maximum	53.88
Zeros	7961
Zeros (%)	0.1%
Negative	3965981
Negative (%)	47.3%
Memory size	64.0 MiB

Quantile statistics

Minimum	-52.68
5-th percentile	-5.88
Q1	-2.38
median	0.08
Q3	2.54
95-th percentile	6.03
Maximum	53.88
Range	106.56
Interquartile range (IQR)	4.92

Descriptive statistics

Standard deviation	3.9098851
Coefficient of variation (CV)	44.218915
Kurtosis	3.363619
Mean	0.088421101
Median Absolute Deviation (MAD)	2.46
Skewness	0.11818784
Sum	713242.8
Variance	15.287202
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	8578	0.1%
0.23	8562	0.1%
-0.17	8559	0.1%
-1.75	8549	0.1%
-0.07	8540	0.1%
1.75	8529	0.1%
-0.01	8525	0.1%
1.5	8523	0.1%
-0.81	8516	0.1%
1.2	8516	0.1%
Other values (6626)	7981035	95.1%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-52.68	1	< 0.1%
-50.14	1	< 0.1%
-48.91	1	< 0.1%
-47.52	1	< 0.1%
-47.48	1	< 0.1%
-47.35	1	< 0.1%
-46.25	1	< 0.1%
-45.65	1	< 0.1%
-45.57	1	< 0.1%
-45.16	1	< 0.1%

Value	Count	Frequency (%)
53.88	1	< 0.1%
52.91	1	< 0.1%
52.46	1	< 0.1%
52.4	1	< 0.1%
52.31	1	< 0.1%
52.17	1	< 0.1%
52.15	1	< 0.1%
52.1	1	< 0.1%
51.86	1	< 0.1%
51.33	1	< 0.1%

bz_gsm
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	7010
Distinct (%)	0.1%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	-0.02912843

Minimum	-55.69
Maximum	72.45
Zeros	12539
Zeros (%)	0.1%
Negative	4021429
Negative (%)	47.9%
Memory size	64.0 MiB

Quantile statistics

Minimum	-55.69
5-th percentile	-5.24
Q1	-1.8
median	0
Q3	1.79
95-th percentile	5.15
Maximum	72.45
Range	128.14
Interquartile range (IQR)	3.59

Descriptive statistics

Standard deviation	3.43058
Coefficient of variation (CV)	-117.77429
Kurtosis	7.9667826
Mean	-0.02912843
Median Absolute Deviation (MAD)	1.79
Skewness	-0.33387524
Sum	-234962.5
Variance	11.768879
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.17	13197	0.2%
0.03	13147	0.2%
-0.12	13127	0.2%
-0.01	13104	0.2%
-0.2	13099	0.2%
0.12	13083	0.2%
0.23	13078	0.2%
0.01	13055	0.2%
0.2	13050	0.2%
-0.04	13046	0.2%
Other values (7000)	7935446	94.6%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-55.69	1	< 0.1%
-55.57	1	< 0.1%
-54.99	1	< 0.1%
-54.94	1	< 0.1%
-54.93	1	< 0.1%
-54.67	1	< 0.1%
-54.46	1	< 0.1%
-54.42	1	< 0.1%
-54.36	1	< 0.1%
-54.27	1	< 0.1%

Value	Count	Frequency (%)
72.45	1	< 0.1%
52.86	1	< 0.1%
52.54	1	< 0.1%
52.31	1	< 0.1%
51.6	1	< 0.1%
50.8	1	< 0.1%
50.52	1	< 0.1%
50.05	1	< 0.1%
49.58	1	< 0.1%
48.59	1	< 0.1%

theta_gsm
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	17965
Distinct (%)	0.2%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	0.19676914

Minimum	-89.91
Maximum	89.96
Zeros	928
Zeros (%)	< 0.1%
Negative	4027157
Negative (%)	48.0%
Memory size	64.0 MiB

Quantile statistics

Minimum	-89.91
5-th percentile	-55.54
Q1	-22.79
median	0.06
Q3	23.13
95-th percentile	56.41
Maximum	89.96
Range	179.87
Interquartile range (IQR)	45.92

Descriptive statistics

Standard deviation	33.278891
Coefficient of variation (CV)	169.12657
Kurtosis	-0.37915177
Mean	0.19676914
Median Absolute Deviation (MAD)	22.96
Skewness	0.010439579
Sum	1587224.9
Variance	1107.4846
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.52	1060	< 0.1%
1.78	1053	< 0.1%
-5.61	1041	< 0.1%
-4.38	1041	< 0.1%
1.17	1040	< 0.1%
-1.45	1035	< 0.1%
-0.59	1030	< 0.1%
-6.89	1029	< 0.1%
0.4	1028	< 0.1%
-5.91	1028	< 0.1%
Other values (17955)	8056047	96.0%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-89.91	1	< 0.1%
-89.89	1	< 0.1%
-89.85	1	< 0.1%
-89.82	3	< 0.1%
-89.79	1	< 0.1%
-89.78	1	< 0.1%
-89.77	2	< 0.1%
-89.76	3	< 0.1%
-89.74	1	< 0.1%
-89.73	2	< 0.1%

Value	Count	Frequency (%)
89.96	1	< 0.1%
89.93	1	< 0.1%
89.91	1	< 0.1%
89.89	1	< 0.1%
89.87	1	< 0.1%
89.85	1	< 0.1%
89.84	1	< 0.1%
89.83	2	< 0.1%
89.82	2	< 0.1%
89.81	2	< 0.1%

phi_gsm
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	36001
Distinct (%)	0.4%
Missing	326388
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	194.37122

Minimum	0
Maximum	360
Zeros	100
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	64.0 MiB

Quantile statistics

Minimum	0
5-th percentile	28.3
Q1	124.69
median	177.66
Q3	286.56
95-th percentile	340.84
Maximum	360
Range	360
Interquartile range (IQR)	161.87

Descriptive statistics

Standard deviation	96.828179
Coefficient of variation (CV)	0.49816109
Kurtosis	-1.0575693
Mean	194.37122
Median Absolute Deviation (MAD)	77.69
Skewness	-0.032815425
Sum	1.567785 × 10⁹
Variance	9375.6962
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
142.44	495	< 0.1%
144.69	484	< 0.1%
143.03	478	< 0.1%
142.36	478	< 0.1%
153.61	476	< 0.1%
142.17	476	< 0.1%
141.96	472	< 0.1%
143.35	471	< 0.1%
151.83	470	< 0.1%
139.47	469	< 0.1%
Other values (35991)	8061163	96.1%
(Missing)	326388	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	100	< 0.1%
0.01	171	< 0.1%
0.02	144	< 0.1%
0.03	198	< 0.1%
0.04	195	< 0.1%
0.05	172	< 0.1%
0.06	193	< 0.1%
0.07	174	< 0.1%
0.08	183	< 0.1%
0.09	171	< 0.1%

Value	Count	Frequency (%)
360	80	< 0.1%
359.99	180	< 0.1%
359.98	171	< 0.1%
359.97	195	< 0.1%
359.96	182	< 0.1%
359.95	164	< 0.1%
359.94	193	< 0.1%
359.93	174	< 0.1%
359.92	171	< 0.1%
359.91	177	< 0.1%

bt
Real number (ℝ)

MISSING

Distinct	5135
Distinct (%)	0.1%
Missing	325888
Missing (%)	3.9%
Infinite	0
Infinite (%)	0.0%
Mean	5.6062266

Minimum	0.03
Maximum	80.53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	64.0 MiB

Quantile statistics

Minimum	0.03
5-th percentile	2.28
Q1	3.64
median	4.95
Q3	6.72
95-th percentile	11.11
Maximum	80.53
Range	80.5
Interquartile range (IQR)	3.08

Descriptive statistics

Standard deviation	3.1100016
Coefficient of variation (CV)	0.55474062
Kurtosis	18.7539
Mean	5.6062266
Median Absolute Deviation (MAD)	1.48
Skewness	2.8092996
Sum	45222246
Variance	9.6721102
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.84	17151	0.2%
3.8	17034	0.2%
4.06	16803	0.2%
3.76	16645	0.2%
3.59	16553	0.2%
3.96	16526	0.2%
4.23	16519	0.2%
4.31	16433	0.2%
3.55	16405	0.2%
3.72	16404	0.2%
Other values (5125)	7899959	94.1%
(Missing)	325888	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.03	2	< 0.1%
0.05	1	< 0.1%
0.07	3	< 0.1%
0.08	4	< 0.1%
0.09	5	< 0.1%
0.1	1	< 0.1%
0.11	5	< 0.1%
0.12	7	< 0.1%
0.13	7	< 0.1%
0.14	17	< 0.1%

Value	Count	Frequency (%)
80.53	1	< 0.1%
79.71	1	< 0.1%
78.78	1	< 0.1%
73.69	1	< 0.1%
72.58	1	< 0.1%
72.51	1	< 0.1%
72.11	1	< 0.1%
71.97	1	< 0.1%
71.68	1	< 0.1%
71.64	1	< 0.1%

density
Real number (ℝ)

MISSING

Distinct	7481
Distinct (%)	0.1%
Missing	684890
Missing (%)	8.2%
Infinite	0
Infinite (%)	0.0%
Mean	4.4217257

Minimum	0
Maximum	199.7
Zeros	3704
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	64.0 MiB

Quantile statistics

Minimum	0
5-th percentile	0.58
Q1	1.79
median	3.34
Q3	5.71
95-th percentile	11.61
Maximum	199.7
Range	199.7
Interquartile range (IQR)	3.92

Descriptive statistics

Standard deviation	4.3319107
Coefficient of variation (CV)	0.97968778
Kurtosis	75.843437
Mean	4.4217257
Median Absolute Deviation (MAD)	1.82
Skewness	5.0431686
Sum	34080142
Variance	18.76545
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	15634	0.2%
1.5	15317	0.2%
2.1	15247	0.2%
1.6	14857	0.2%
2.4	14844	0.2%
1.75	14774	0.2%
1.9	14710	0.2%
2.04	14687	0.2%
1.8	14668	0.2%
2.08	14607	0.2%
Other values (7471)	7558085	90.1%
(Missing)	684890	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3704	< 0.1%
0.01	3549	< 0.1%
0.02	2341	< 0.1%
0.03	2635	< 0.1%
0.04	3170	< 0.1%
0.05	3230	< 0.1%
0.06	4769	0.1%
0.07	5403	0.1%
0.08	4687	0.1%
0.09	5303	0.1%

Value	Count	Frequency (%)
199.7	1	< 0.1%
195.26	1	< 0.1%
193.47	1	< 0.1%
192.72	1	< 0.1%
192.23	1	< 0.1%
191.68	1	< 0.1%
191.46	1	< 0.1%
190.79	1	< 0.1%
190.53	1	< 0.1%
190.31	1	< 0.1%

speed
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	64036
Distinct (%)	0.8%
Missing	689555
Missing (%)	8.2%
Infinite	0
Infinite (%)	0.0%
Mean	430.5854

Minimum	0
Maximum	1198.49
Zeros	628
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	64.0 MiB

Quantile statistics

Minimum	0
5-th percentile	300.9
Q1	356.8
median	409.7
Q3	485.66
95-th percentile	628.5
Maximum	1198.49
Range	1198.49
Interquartile range (IQR)	128.86

Descriptive statistics

Standard deviation	100.57773
Coefficient of variation (CV)	0.23358369
Kurtosis	0.72396492
Mean	430.5854
Median Absolute Deviation (MAD)	60.65
Skewness	0.9092821
Sum	3.3166982 × 10⁹
Variance	10115.879
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
379.1	1213	< 0.1%
376.8	1210	< 0.1%
378.2	1208	< 0.1%
377.6	1188	< 0.1%
378.5	1186	< 0.1%
380.4	1183	< 0.1%
379.8	1181	< 0.1%
378.7	1176	< 0.1%
368.5	1176	< 0.1%
378.4	1176	< 0.1%
Other values (64026)	7690868	91.6%
(Missing)	689555	8.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	628	< 0.1%
224.72	7	< 0.1%
224.96	1	< 0.1%
224.98	1	< 0.1%
224.99	2	< 0.1%
225.05	1	< 0.1%
225.06	4	< 0.1%
225.08	1	< 0.1%
225.1	2	< 0.1%
225.12	3	< 0.1%

Value	Count	Frequency (%)
1198.49	1	< 0.1%
1166.53	1	< 0.1%
1159.7	1	< 0.1%
1152.7	1	< 0.1%
1151.4	2	< 0.1%
1148.5	1	< 0.1%
1147.84	1	< 0.1%
1147	1	< 0.1%
1145.9	1	< 0.1%
1144.1	1	< 0.1%

temperature
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	541646
Distinct (%)	7.1%
Missing	811768
Missing (%)	9.7%
Infinite	0
Infinite (%)	0.0%
Mean	115096.76

Minimum	0
Maximum	6223700
Zeros	646
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	64.0 MiB

Quantile statistics

Minimum	0
5-th percentile	16123
Q1	39787
median	77371
Q3	151220
95-th percentile	326725.45
Maximum	6223700
Range	6223700
Interquartile range (IQR)	111433

Descriptive statistics

Standard deviation	120312.04
Coefficient of variation (CV)	1.0453122
Kurtosis	33.961546
Mean	115096.76
Median Absolute Deviation (MAD)	46099
Skewness	3.7865275
Sum	8.7249694 × 10¹¹
Variance	1.4474987 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	646	< 0.1%
108000	229	< 0.1%
105000	226	< 0.1%
106000	224	< 0.1%
109000	222	< 0.1%
121000	211	< 0.1%
123000	211	< 0.1%
125000	207	< 0.1%
111000	207	< 0.1%
114000	206	< 0.1%
Other values (541636)	7577963	90.3%
(Missing)	811768	9.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	646	< 0.1%
1496	1	< 0.1%
1632	1	< 0.1%
1829	1	< 0.1%
1879	1	< 0.1%
1915	1	< 0.1%
1922	1	< 0.1%
1925	1	< 0.1%
1980	1	< 0.1%
1983	1	< 0.1%

Value	Count	Frequency (%)
6223700	1	< 0.1%
6046900	1	< 0.1%
5751308	1	< 0.1%
5543300	1	< 0.1%
5387600	1	< 0.1%
5052500	1	< 0.1%
5024886	1	< 0.1%
4206672	1	< 0.1%
4035915	1	< 0.1%
4016337	1	< 0.1%

source
Categorical

HIGH CORRELATION MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	316816
Missing (%)	3.8%
Memory size	64.0 MiB

ac	6630304
ds	1445200

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	16151008
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ac
2nd row	ac
3rd row	ac
4th row	ac
5th row	ac

Common Values

Value	Count	Frequency (%)
ac	6630304	79.0%
ds	1445200	17.2%
(Missing)	316816	3.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ac	6630304	82.1%
ds	1445200	17.9%

Most occurring characters

Value	Count	Frequency (%)
a	6630304	41.1%
c	6630304	41.1%
d	1445200	8.9%
s	1445200	8.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	16151008	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6630304	41.1%
c	6630304	41.1%
d	1445200	8.9%
s	1445200	8.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16151008	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6630304	41.1%
c	6630304	41.1%
d	1445200	8.9%
s	1445200	8.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16151008	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	6630304	41.1%
c	6630304	41.1%
d	1445200	8.9%
s	1445200	8.9%

Auto

Heatmap
Table

	bt	bx_gse	bx_gsm	by_gse	by_gsm	bz_gse	bz_gsm	density	period	phi_gse	phi_gsm	source	speed	temperature	theta_gse	theta_gsm
bt	1.000	-0.187	-0.187	0.083	0.078	-0.018	-0.021	0.263	0.126	-0.042	-0.043	0.068	0.188	0.232	-0.022	-0.026
bx_gse	-0.187	1.000	1.000	-0.403	-0.394	0.074	0.071	0.017	0.079	0.316	0.312	0.070	-0.013	-0.011	0.063	0.060
bx_gsm	-0.187	1.000	1.000	-0.402	-0.393	0.074	0.071	0.017	0.079	0.315	0.311	0.070	-0.013	-0.011	0.063	0.060
by_gse	0.083	-0.403	-0.402	1.000	0.963	-0.058	-0.059	-0.002	0.087	-0.768	-0.740	0.044	0.029	0.023	-0.049	-0.053
by_gsm	0.078	-0.394	-0.393	0.963	1.000	-0.052	-0.052	-0.003	0.059	-0.739	-0.768	0.036	0.026	0.022	-0.042	-0.045
bz_gse	-0.018	0.074	0.074	-0.058	-0.052	1.000	0.910	-0.002	0.100	0.041	0.038	0.052	-0.005	-0.003	0.967	0.888
bz_gsm	-0.021	0.071	0.071	-0.059	-0.052	0.910	1.000	-0.014	0.091	0.043	0.039	0.048	-0.017	-0.013	0.887	0.965
density	0.263	0.017	0.017	-0.002	-0.003	-0.002	-0.014	1.000	0.036	-0.021	-0.019	0.038	-0.102	-0.005	-0.009	-0.022
period	0.126	0.079	0.079	0.087	0.059	0.100	0.091	0.036	1.000	0.029	0.029	0.593	-0.049	-0.052	0.023	0.033
phi_gse	-0.042	0.316	0.315	-0.768	-0.739	0.041	0.043	-0.021	0.029	1.000	0.853	0.076	-0.015	0.028	0.035	0.041
phi_gsm	-0.043	0.312	0.311	-0.740	-0.768	0.038	0.039	-0.019	0.029	0.853	1.000	0.077	-0.014	0.027	0.030	0.036
source	0.068	0.070	0.070	0.044	0.036	0.052	0.048	0.038	0.593	0.076	0.077	1.000	0.050	0.148	-0.005	-0.021
speed	0.188	-0.013	-0.013	0.029	0.026	-0.005	-0.017	-0.102	-0.049	-0.015	-0.014	0.050	1.000	0.746	-0.005	-0.017
temperature	0.232	-0.011	-0.011	0.023	0.022	-0.003	-0.013	-0.005	-0.052	0.028	0.027	0.148	0.746	1.000	-0.005	-0.017
theta_gse	-0.022	0.063	0.063	-0.049	-0.042	0.967	0.887	-0.009	0.023	0.035	0.030	-0.005	-0.005	-0.005	1.000	0.921
theta_gsm	-0.026	0.060	0.060	-0.053	-0.045	0.888	0.965	-0.022	0.033	0.041	0.036	-0.021	-0.017	-0.017	0.921	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	period	timedelta	bx_gse	by_gse	bz_gse	theta_gse	phi_gse	bx_gsm	by_gsm	bz_gsm	theta_gsm	phi_gsm	bt	density	speed	temperature	source
0	train_a	0 days 00:00:00	-5.55	3.00	1.25	11.09	153.37	-5.55	3.00	1.25	11.09	153.37	6.80	1.53	383.92	110237.0	ac
1	train_a	0 days 00:01:00	-5.58	3.16	1.17	10.10	151.91	-5.58	3.16	1.17	10.10	151.91	6.83	1.69	381.79	123825.0	ac
2	train_a	0 days 00:02:00	-5.15	3.66	0.85	7.87	146.04	-5.15	3.66	0.85	7.87	146.04	6.77	1.97	389.11	82548.0	ac
3	train_a	0 days 00:03:00	-5.20	3.68	0.68	6.17	146.17	-5.20	3.68	0.68	6.17	146.17	6.74	1.97	389.11	82548.0	ac
4	train_a	0 days 00:04:00	-5.12	3.68	0.49	4.62	145.72	-5.12	3.68	0.49	4.62	145.72	6.65	1.77	384.26	94269.0	ac
5	train_a	0 days 00:05:00	-4.78	3.86	0.05	0.80	142.47	-4.78	3.86	0.05	0.80	142.47	6.54	0.93	367.98	28227.0	ac
6	train_a	0 days 00:06:00	-5.15	3.53	0.52	4.80	147.06	-5.15	3.53	0.52	4.80	147.06	6.63	1.74	384.72	87302.0	ac
7	train_a	0 days 00:07:00	-5.35	3.06	1.21	10.81	152.06	-5.35	3.06	1.21	10.81	152.06	6.65	1.70	382.41	101225.0	ac
8	train_a	0 days 00:08:00	-5.77	2.69	0.73	6.66	156.36	-5.77	2.69	0.73	6.66	156.36	6.70	1.10	357.36	79922.0	ac
9	train_a	0 days 00:09:00	-6.07	2.20	0.27	2.65	161.24	-6.07	2.20	0.27	2.65	161.24	6.80	1.77	380.53	125156.0	ac

	period	timedelta	bx_gse	by_gse	bz_gse	theta_gse	phi_gse	bx_gsm	by_gsm	bz_gsm	theta_gsm	phi_gsm	bt	density	speed	temperature	source
8392310	train_c	2435 days 23:50:00	-1.69	2.30	-3.55	-51.14	126.29	-1.69	3.18	-2.80	-37.85	117.94	4.56	3.24	345.52	28332.0	ac
8392311	train_c	2435 days 23:51:00	-1.75	2.28	-3.57	-51.13	127.55	-1.75	3.16	-2.82	-38.02	118.94	4.58	3.96	345.29	28885.0	ac
8392312	train_c	2435 days 23:52:00	-1.09	1.95	-3.90	-60.21	119.22	-1.08	2.93	-3.23	-45.99	110.33	4.49	4.06	346.63	26783.0	ac
8392313	train_c	2435 days 23:53:00	-0.76	1.66	-4.07	-65.89	114.70	-0.76	2.69	-3.48	-51.21	105.72	4.46	4.25	348.69	25860.0	ac
8392314	train_c	2435 days 23:54:00	-0.56	1.48	-4.14	-69.05	110.53	-0.55	2.54	-3.59	-54.07	102.26	4.43	4.36	351.33	33577.0	ac
8392315	train_c	2435 days 23:55:00	-1.18	2.00	-3.92	-59.28	120.51	-1.17	2.98	-3.23	-45.24	111.48	4.56	4.64	348.73	23368.0	ac
8392316	train_c	2435 days 23:56:00	-1.34	2.12	-3.83	-56.78	122.23	-1.33	3.08	-3.12	-42.95	113.45	4.58	4.27	346.36	26497.0	ac
8392317	train_c	2435 days 23:57:00	-1.62	2.33	-3.63	-51.98	124.76	-1.61	3.22	-2.87	-38.57	116.58	4.61	3.95	344.12	27050.0	ac
8392318	train_c	2435 days 23:58:00	-2.27	2.48	-3.22	-43.81	132.50	-2.26	3.25	-2.44	-31.61	124.81	4.65	2.81	338.52	33257.0	ac
8392319	train_c	2435 days 23:59:00	-2.15	2.41	-3.30	-45.55	131.76	-2.15	3.21	-2.53	-33.21	123.75	4.62	2.30	342.31	32267.0	ac

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample